package com.dp.appi.dao;


import java.util.List;
import java.util.Map;

/**
 * Created by bchen on 2016/5/23.
 */
public interface ProjectStatisticsDao extends BaseDao {

    /**
     * 个人项目进度统计
     *id
     * @return
     */
    List<Map<String, java.lang.Object>> scheduleCount(Object id,Object org_id);

    /**
     * 阶段线路杆塔明细
     * @param voltageGrade
     * @param stageId
     * @return
     */
    List<Map<String,Object>> poleSum(String voltageGrade, Long stageId,int classify);

    /**
     * 阶段台区材料统计
     * @param explor_id
     * @return
     */
    List<Map<String,Object>> materialSum(Long stage_id,Integer classify, Long explor_id,String exploration_type);

    /**
     * 阶段用电户
     * @param stage_id
     * @return
     */
    List<Map<String,Object>> userPoint(Long stage_id,int classify);

    /**
     * 项目设计阶段统计
     * @param id
     * @return
     */
    List<Map<String,Object>> projectSum(Map<String, String> param,String id,String groupBy,Object org_id);

    /**
     * 交叉跨越描述
     * @param explorId
     * @return
     */
    String describe(Long stage_id,Integer classify,Long explorId,String exploration_type);

    /**
     * 交叉跨越列表
     * @param explorId
     * @return
     */
    List<Map<String,Object>> corssList(Long stage_id,Integer classify,Long explor_id,String exploration_type);

    /**
     * 阶段交叉跨越
     * @param stage_id
     * @return
     */
    List<Map<String,Object>> pointSum(Long stage_id,int classify);

    /**
     * 按电压等级统计里程、杆塔数量
     * @param explorList
     * @return
     */
    List<Map<String,Object>> routeList(List<Map<String, Object>> explorList);
    /**
     * 按电压等级统计里程、杆塔数量
     * @param explor_id
     * @return
     */
    List<Map<String,Object>> routeList1(Long explor_id);

    /**
     * 按电压等级统计里程、杆塔数量
     * @param stage_id
     * @param classify
     * @return
     */
    List<Map<String,Object>> routeListByV(Long stage_id,int classify,Long explor_id);

    /**
     * 项目阶段台区统计
     * @param explor_id
     * @return
     */
    Map<String,Object> explorSum(Long explor_id);
}
